CygNet FMS History Grid Control

CygNet Measurement > FMS ActiveX Controls > CygNet FMS History Grid Control

CygNet FMS History Grid Control

History Grid Control icon The CygNet FMS History Grid Control is an ActiveX control used for viewing and editing measurement data. Each row of the grid displays data for a single selected device or station. Each column represents a category of data.

See Using the History Grid Control for more information about configuring and using this control.

See CxFmsHistoryGridCtrl Object in the Scripting section for more information about scripting this control.

Adding a History Grid Control to a Screen

To Add and Configure a CygNet FMS History Grid Control in CygNet Studio

Create a new CygNet Studio screen.
Click the ActiveX tool on the Standard Tools palette.
Click and drag the outline of a box on the screen. When the mouse button is released, an Insert OLE Control dialog box appears.
In the dialog box, double-click on CygNet FMS History Grid Control to place a History Grid control on your screen.
Right-click the control to open its property sheet.
On the ActiveX page, click ... or double-click (OCXProperties) to access the CygNet FMS history Grid Control Properties dialog box.
The CygNet FMS History Grid control contains a General tab, a Grid tab, and a Commands tab.
Configure properties on each page as desired, click Apply, and then click OK.
Close the property sheet, save, and then switch to Run mode to use the control.

General Properties

The General page of the CygNet FMS history Grid Control Properties dialog box contains the following properties.

General Properties

Property	Description
General
FMS service	Type the name of the Site.Service to which to connect in the control's Chooser, or click ... to access the Select Service dialog box.
Use Point in Time mode	Click the check box to select/clear the option to use the Point in Time mode.
PIT (C)	If Use Point in Time mode is selected, do one of the following. Type the desired date/time value into the text box. Click ... to access the Select Date and Time dialog box, then enter the date/time, in Contract time (C), from which you want to view data. Default value is T, date and time today. See Using the Home Menu for more information about PIT mode.
Use Session Node	Click the check box to select/clear the option to Use Session Node instead of using the chooser. Default value is cleared.
Use Session options	Click the check box to select/clear the option to Use Session options instead of entering a time window and time format. Default value is cleared.
Show Chooser pane	Click the check box to select/clear the option to display the Chooser pane in the control. Default value is selected.
Show Options pane	Click the check box to select/clear the option to display the Options pane in the control. Default value is selected.
Node Chooser
Allow FMS service selection	Click the check box to select/clear the option to show the FMS service selector in the control's Chooser.
Allow Node category selection	Click the check box to select/clear the option to show the Node category selector in the control's Chooser.
Category	Select the desired Node Category to display in the control's Chooser from the drop-down menu. Options include the following, as applicable to the control. Device Gas Device Liquid Device Station
Group	Select the desired Node Group type to display in the control's Chooser from the drop-down menu. Options are as follows. All Nodes General Station By Category
Filter	Select a filter. First type a partial string of known Node name/description/ID characters to populate the filter text box in the control's Chooser. Wildcard values * (multiple character) and ? (single character) are supported. Default value is * (multiple character wildcard) - all. Note: Wildcards can be used only when filtering by Name or Desc, not when filtering by ID. Then select a Node option to filter for results. Options are as follows. Name Desc ID
Primary column	Select the desired primary sort column in the control's Chooser from the drop-down menu. Options include the following Type ascending Name ascending Description ascending Type descending Name descending Description descending Default value is Name ascending
Date
Start	Date selections are in Contract days (C). Enter the starting date (absolute or relative date) in the text box or click ... to access the Select Date dialog box. See Selecting Date and Time for more information.
End	Date selections are in Contract days (C). Enter the ending date (absolute or relative date) in the text box or click ... to access the Select Date dialog box. See Selecting Date and Time for more information.
Format	Select the desired time format from the drop-down menu. Options are as follows. Device Contract Local

See Using the History Grid Control for more information about configuring these properties.

Grid Properties

The Grid page of the CygNet FMS History Grid Control Properties dialog box contains the following properties.

Grid Properties

Property	Description
Show units	Click the check box to select/clear display of data units in the grid, where applicable. Default value is cleared (units not shown).
Unit set	Select a Unit set in which to view the data. Options appear in the drop-down menu, which is populated by the unit sets defined in the service, and includes a default unit set.
	Click to Refresh the available unit set list
Columns	Click ... to access the History Grid Columns dialog box to select columns for display in the control. The data fields available to be viewed in the columns correspond to the data view selected, and you can select the sets of columns to appear for each data view. Options include data items corresponding to the following. Gas Device - custom columns listed are as configured in the Admin Options, Custom Device Data page Gas Station See Using the History Grid Control for more information about columns.
Station meter view	Click to select a Station meter view mode from the drop-down menu. Options are as follows. Device Station
Record span	Click to access the drop-down menu to select a Record span for display of history data. Options are as follows. Daily Hourly Native Default value is Native.
Record order	Click to access the drop-down menu to select a Record order for display of history data. Options are as follows. Oldest first Newest first Default value is Oldest first.
Decimal precision	Click to select a Decimal precision for the display from the drop-down menu. Options are from 0 - 10 decimal places. Default value is 7. Note: Although values are shown in the History Grid control with a decimal precision of up to 10 places, device Node values are shown in the Batch, Ticket, Liquid Device QTR, and Liquid Device Raw QTR reports with a decimal precision of 15 places.
Grid color	Click to access the drop-down menu to select a Grid color element to visually identify problematic or edited records by applying color to the grid. Options are as follows. None Row background Row text Date/Time background Date/Time text Default value is Row background. Note: Grid color selections other than "None" will automatically apply color to records with "System..." or "User..." Data Source values. See Data Source Values in the CygNet Measurement Concepts topic for more information. For grid element color options other than "None" you can also optionally color records with low data quality values or records having exceptions. To color these problematic records, use the following Low data quality threshold and Exceptions options.
Low data quality threshold	When a Grid color option other than "None" is selected, the Low data quality threshold menu becomes available. Select a value from the options in the drop-down menu. Color will be applied to records with lower data quality than this selected value. Note: This grid color option also colors records with "Device" or "Device File" or "Imported" Data Source values. Default value is the data quality value configured in your system settings, using the Admin menu. See Configuring Data Quality Settings for more information.
	Click to Refresh the available low data quality threshold options.
Exceptions	When a Grid color option other than "None" is selected, the Exceptions check box becomes available. Click the check box to select/clear the option to color records red if they have exceptions (bad data). Note: This grid color option also colors records with "Device" or "Device File" or "Imported" Data Source values. Default value is selected (color records with exceptions).

See Using the History Grid Control for more information about configuring these properties.

Commands Properties

The Commands page of the CygNet FMS history Grid Control Properties dialog box contains the following options.

Commands Properties

See Managing Node Commands for more information about configuring commands for the FMS History Grid control.

CygNet FMS History Grid Control – Properties, Methods, and Events